Scriptbox - Find your Script, VBScript VBScripts VB-Script VB-Scripts Scripting

Loading

:: { Category } ::

0-9


	Search Options: Add a Total Row to an Excel Spreadsheet Content of Add a Total Row to an Excel Spreadsheet.vbs MD5 Hash: 4886D3C6E910E02259AEB6B006A44E80
	arrValues = Array(1,5,7,9,11,13,15,17) Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.Workbooks.Add i = 1 For Each intValue in arrValues objExcel.Cells(i, 1).Value = intValue i = i + 1 Next objExcel.Cells(i, 1).Formula = "=SUM(A1:A" & i - 1 & ")"

© 2008 - 2013 Boris Toll :: Scripts available: 6.481 :: :: scriptbox.toll.at :: :: powered by www.toll.at ::